package org.database;

public class Statements {
	public static final String UPDATE_IMAGE = "update testimage set image = ? , imagesignature = ? where id = ?";
	public static final String SELECT_IMAGE = "select image from testImage where id = ? for update ";
	public static final String INSERT_IMAGE = "begin insert into testimage(id, image, imagesignature)"
			+ " values (image_seq.nextVal, ordimage.init(), ordimagesignature.init()) "
			+ "returning image, imagesignature, id into ?, ?, ?;end;";
	public static final String SELECT_ROW = "select * from testImage where id = ? for update ";
	public static final String UPDATE_SIGNATURE = "update testimage set imagesignature = ? where id = ?";
	public static final String SELECT_ALL = "select * from testimage for update";
}
